SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '0d9c78cae0f1e61bd6c1f75200636c3b77a8a5c27a44bd36bf3d25686de27356' 
  AND token = 'zlCbr9d8Y0xEWRgF2vtYpNKZKUHnT/hcEEDZ0dkpw9s=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00021

JSON explain

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