UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0P3imtY0GUFZblWnittS3hkvCTvvrbHQl95DjzrBB/E='
WHERE
key_id = '508701741067bc1c6a580b403813135351cd595f9b346fde2aacb07154aa9d25'
AND (
token = '0P3imtY0GUFZblWnittS3hkvCTvvrbHQl95DjzrBB/E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)