UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'Tbf/dogKfweLwiG8O9GTcVQPmZZWl+ntkPOMud66dfg=' 
WHERE 
  key_id = 'ebff19f5807db6bc8d913f461ab9658aae09f16cbee9cc08f63baa222c694723' 
  AND (
    token = 'Tbf/dogKfweLwiG8O9GTcVQPmZZWl+ntkPOMud66dfg=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00043