UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'roE1bQpbAqUbL/Drm8qF2egovC6fR3B24UODfDTf6uA='
WHERE
key_id = 'ba34ecf43eaba1e0ea12b0fcaa26be73022f0fd0688fd3de57fae00fe3fa86bd'
AND (
token = 'roE1bQpbAqUbL/Drm8qF2egovC6fR3B24UODfDTf6uA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)