UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bsgIYnpHo4gM7gfZwaJUC4ugDKX4YZRai3a6lEB4YO4='
WHERE
key_id = 'aa14b88bbb4e00ff1ac2dd76c95e567679c7396a84aeac87357577a04ce3c6e6'
AND (
token = 'bsgIYnpHo4gM7gfZwaJUC4ugDKX4YZRai3a6lEB4YO4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)