SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = 'db8cfc1f918ab618d9498ca2c4f6f6f0d5cd31dcb99a8eb56151b1142b32a951' 
  AND token = 'WEKqMAACtH5BA1co9n5EVd4L96o1i7b2OcV7m8EJOkM=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00092

JSON explain

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