SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = 'ddf5f7ee3e0321841fec2c1800cae0d4728d7d43b2a812ce4535928506029c58' 
  AND token = 'ClUM+v97Vk1MT1gv7z0BBbGoCrHePnVxheMHO55Abdw=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00024

JSON explain

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