UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'j+o6x9+SANTCHrxaMFTWF2P/EzdMgTvghm415HmZzUY='
WHERE
key_id = 'aea7738945daf8680c6488973b58fe76621f8cd148ff13e762aac7e7b4943499'
AND (
token = 'j+o6x9+SANTCHrxaMFTWF2P/EzdMgTvghm415HmZzUY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)