UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'WDKAHcYfIK4gLQ8CJ2veg/tBNefINq2fL/SQEODiVOU='
WHERE
key_id = 'e6f545623c20eff3fe8fa9f0efaee8880ed277ca0dc890eb47768b29c7dc41f2'
AND (
token = 'WDKAHcYfIK4gLQ8CJ2veg/tBNefINq2fL/SQEODiVOU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)