UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yHKw8xf29HVXe7NLUzYatZaICGGaRA5RfS+zXZPcLmE='
WHERE
key_id = 'e93c5067f90bddd57926e146858a432230fbea06c33b8b2e2789ba8cb97a6d2e'
AND (
token = 'yHKw8xf29HVXe7NLUzYatZaICGGaRA5RfS+zXZPcLmE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)