UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7tlwMjkIr8pH/pnbqxWlZMKYSqH0Hv2cIVLsyFWVaBg='
WHERE
key_id = '49f8a1ac8342ee03d409aecc73b0776c142d6755955eda3852b0fa0d32f1777e'
AND (
token = '7tlwMjkIr8pH/pnbqxWlZMKYSqH0Hv2cIVLsyFWVaBg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)