UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'GkUW2E3zFKokZjq+i9z9+u66yrQSFPS1VzCgMx16Dhk=' 
WHERE 
  key_id = '473f89e502355d9d0ce95ee05a8b3aa0ff2b6cf9cedd8c77a3dbaeedf6a2de69' 
  AND (
    token = 'GkUW2E3zFKokZjq+i9z9+u66yrQSFPS1VzCgMx16Dhk=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00045