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