SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '0df08c5179b921ada2b5a24951676a3df34e269299ec8c6fe3f619a24afc35a7' 
  AND token = 'tDGyKi/yzeEc2m6h04mDQ6v+V6D7nV7aQ80/2I+8RAc=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00020

JSON explain

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