UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QMqrRWwi/eeHGt0/Z0LtvB5Hut8LDpjova/qGHgvHEw='
WHERE
key_id = 'b363861a7cb80cd66df2a9a3913db5df05a3eeb86852d0a2e2d6124beed9cd3f'
AND (
token = 'QMqrRWwi/eeHGt0/Z0LtvB5Hut8LDpjova/qGHgvHEw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)