UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CnZzPhTTaZXKXdP6HPIyMdujm+3aGN7C38ihUhpg6rk='
WHERE
key_id = 'bf7d5e5dedd4789d101c044a57c94868ca8a008b93407f8929fc41edfaadbc15'
AND (
token = 'CnZzPhTTaZXKXdP6HPIyMdujm+3aGN7C38ihUhpg6rk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)