SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '1ee3f2cb39b73282711c2064a21f2bc112440557e5d5093b295514924dd65c65' 
  AND token = 'TCEaOKKo/1bLi9nRSKPClf+Xa20Bulp52F7T7sOImEA=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00033

JSON explain

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