UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Mi/46wemzHM+oBPhVD556gViXIKgtsZuw+3xvtZPRj4='
WHERE
key_id = 'ab0b1ef0df7801f344a6a2be3457362f621db69292f3963bc4b7b9b6ab9833f2'
AND (
token = 'Mi/46wemzHM+oBPhVD556gViXIKgtsZuw+3xvtZPRj4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)