SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '4728d144b8b72cdd80b7ca83d1d8b4ce7b28f891d4012b7db729dd6ca07dbdd1' 
  AND token = 'Bj4CLV1mPv9G/d7b/vWVXmQ6/MbxOXuUXgNYq+GMSjs=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00015

JSON explain

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