UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2ZuxJ0xgDQRYHybzJ5QHoBVc3S2jpg1Vc3cudO8Bg9o='
WHERE
key_id = '3ba4411b42fd80bbc5c12b8ea4734db791adabe21ff668193abe1186f4ad37c5'
AND (
token = '2ZuxJ0xgDQRYHybzJ5QHoBVc3S2jpg1Vc3cudO8Bg9o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)