UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'loAt4lr4rjRiO71BcSFefhSgxexnShYUWm0bNJDkHHI='
WHERE
key_id = 'f92008ec43f2f7de46e3be7734a73e1d144c262da0c4f312af2be17baebd56c7'
AND (
token = 'loAt4lr4rjRiO71BcSFefhSgxexnShYUWm0bNJDkHHI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)