UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mbJAwnD+rWxTrMCWw5vg2a0g2smInIKbgdxdBPfn9Go='
WHERE
key_id = '6be0bd90faaf3b71309e8a1cbc11feb62ad56a4d4158c1d5dc01d1d6692f27fb'
AND (
token = 'mbJAwnD+rWxTrMCWw5vg2a0g2smInIKbgdxdBPfn9Go='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)