SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '1469436074a51c2d885e858e319696d946bf3f2e89908ac8974743a034dd8c7d' 
  AND token = 'Oz1usPnmF0vYrrHkK+Ilwphl85vS7IAgJBSKBT8v3kY=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00038

JSON explain

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