UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZM5b4PnJ/tygwZggL0NSNMzonVzAxbfL56SaaYvakLg='
WHERE
key_id = 'b2374dca8f7b903425da31c705d1d36b5e3f22e41726ee8b532b38f1f6565004'
AND (
token = 'ZM5b4PnJ/tygwZggL0NSNMzonVzAxbfL56SaaYvakLg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)