UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/J2AFn2reT4GzEAT/wI7GoRX4FvsyLRGf01q9oqKbcQ='
WHERE
key_id = '5946127b2d5dd6d1eac101bf76494b26b206a65be4ad4663262ee299ba429366'
AND (
token = '/J2AFn2reT4GzEAT/wI7GoRX4FvsyLRGf01q9oqKbcQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)