UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'rpBlnsQrqE9cGH/TCCkkdKy1vquN5BWnyqNruwuRcWg='
WHERE
key_id = '4f1395070b43c02e0cf9be90d7f6329cae801f428acd528163a8d04256c30f5a'
AND (
token = 'rpBlnsQrqE9cGH/TCCkkdKy1vquN5BWnyqNruwuRcWg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)