UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zJo54HyeJq+dF/AeNqbSON0ja9mNAw7Vh2RsIA6FUfk='
WHERE
key_id = '287454364099775880c3f69f9829d8d74e7b14f770e03dbd8537b30b25293cee'
AND (
token = 'zJo54HyeJq+dF/AeNqbSON0ja9mNAw7Vh2RsIA6FUfk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)