SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '6ca5fb40f96ad5eabdd077c9ea672004bce3e64f98c3d1c029b3d1391513e353' 
  AND token = 'PvV7ciifXaBCQ6hBZyL+24U6Y1xlMSlhO1mjQ/kCkSQ=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00019

JSON explain

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