UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'b2CcMIGH4wUkqCdN9KWxVWPSYw3Lx4VVRKAjuV3hOok='
WHERE
key_id = '6887ad3b97c910367a4223d67e3e56366b9381ba3eba41e0609a79fb35e8b1ea'
AND (
token = 'b2CcMIGH4wUkqCdN9KWxVWPSYw3Lx4VVRKAjuV3hOok='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)