UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BhnQduQkJ+YXezCHqDQu786whlwAjbcI9j7GDs5n7iE='
WHERE
key_id = 'd2a5e8b7823ba0f937cf1cf9b6553ac111d7cbd91954860a4a66222d6e4dc98b'
AND (
token = 'BhnQduQkJ+YXezCHqDQu786whlwAjbcI9j7GDs5n7iE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)