UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xNTAGAV45K1gsIxHNpnl1wmd+g2Rs6w4tdcHqlM/DPc='
WHERE
key_id = '653f4a090fd70f50dc3db8c9bb4ff167bf20e3b25eddbb9a9589f4d1bce456ec'
AND (
token = 'xNTAGAV45K1gsIxHNpnl1wmd+g2Rs6w4tdcHqlM/DPc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)