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