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

Query time 0.00031

JSON explain

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