UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'k2zNnpG2uN9ngup2AJL/nYAoCgIIQVf9lKSwLcXE5Y0='
WHERE
key_id = 'be288d59f459d677b21d573c6478c8b5ee285192aef112bb3019f8e04febd4af'
AND (
token = 'k2zNnpG2uN9ngup2AJL/nYAoCgIIQVf9lKSwLcXE5Y0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)