SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = 'f27e04ecd684870d852a069e1a7d863bb280d2b32fd3f95354cfd6967d9aba48' 
  AND token = '6LL+DoLDtP+WfYp1Hks0Nm3WAlsBcFvv0kNSbowgrt8=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00076

JSON explain

{
  "query_block": {
    "select_id": 1,
    "message": "no matching row in const table"
  }
}