UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VgDZnepGmqmmLZTYiq/3MJe2Ltzxj0mU0kZfEkd4v04='
WHERE
key_id = '2ef67aa9073f635426490738f08010a5a52258d90827f0a6565f4b60a6f5dea0'
AND (
token = 'VgDZnepGmqmmLZTYiq/3MJe2Ltzxj0mU0kZfEkd4v04='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)