UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3nxckayQsU7FRV2klwKsA3NT++1zKRLvsuNxCV+6KL4='
WHERE
key_id = 'a8eb657ae5c87b813528393a4209aa5fd888c2b87649dead057a2a6b6ce05b65'
AND (
token = '3nxckayQsU7FRV2klwKsA3NT++1zKRLvsuNxCV+6KL4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)