UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9ZmIh/rpUxYXcRjwd4HQfxp1luG1YZFZCsF+MH4hFOU='
WHERE
key_id = '35c69ede83664c37fc065e1b0be1bb060127a8f3ea725741df5799abbe6b913d'
AND (
token = '9ZmIh/rpUxYXcRjwd4HQfxp1luG1YZFZCsF+MH4hFOU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)