SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = 'd20c47dbdb2497980aa12f01d51fd237aa85d05dde2e86c664ffb37b0067fe49' 
  AND token = 'fq9/qO8bUKlU9HnosyvSw0RXuf/WSYY5AJUgR6v0ZYg=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00019

JSON explain

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