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